SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001222s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 425544 LIMIT 1 [ RunTime:0.000346s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 425544 [ RunTime:0.002367s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (763182,517398,689195,367275,658144,185777,282993,575677,938326,386902,292740,594401,915053,644108,130290,835339,349266,806466,272586,112340,375014,657674,535776,580112,14088,327967,947038,755635,43478,298425,287720,165392,1005118,134260,910638,701175,376332,89042,948526,697972,142662,978916,242998,406512,723087,252816,681735,858279,387945,700648,910244,462633,739943,165197,756034,670611,402719,998559,777041,682721) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001335s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 425544 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000456s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 425544 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000671s ]