SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001182s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 685318 LIMIT 1 [ RunTime:0.000370s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 685318 [ RunTime:0.002538s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (805818,344396,968721,710542,601653,119714,37305,579514,317186,582465,716873,114767,400921,751482,124660,55266,160732,738513,273658,462563,424680,907605,923199,754158,601081,347110,827893,941907,727242,449188,774558,251325,490008,651310,32349,367904,257863,834850,335256,373681,913972,142209,601799,366231,252684,306686,154066,842571,141670,561358,882962,49475,831016,220508,289052,187992,857395,839403,1021897,8544) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001017s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 685318 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000413s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 685318 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000448s ]