SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001294s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 435513 LIMIT 1 [ RunTime:0.000417s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 435513 [ RunTime:0.002146s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (857896,55434,999286,308136,221791,934891,341689,28084,804232,885845,205472,547786,224700,238336,331899,503948,436453,355565,280240,713230,803917,242009,46635,721344,867291,788843,715275,761427,1003174,458553,276911,167087,545271,163397,671743,525519,818429,551845,365864,791050,423489,598655,594551,252734,967522,389660,860840,762953,1021456,1000569,822201,337414,112269,963052,95091,537459,699444,819430,639671,718006) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001246s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 435513 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000553s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 435513 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000546s ]