SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001270s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 904810 LIMIT 1 [ RunTime:0.000326s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 904810 [ RunTime:0.001894s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (313887,265765,793065,632002,798506,346795,101138,36717,684866,171935,232661,524119,972115,577887,103772,432049,543597,174642,690138,993088,220537,74320,893568,558956,968636,52312,81905,204605,140886,475326,622235,948915,202844,688653,698652,738496,608096,495619,780800,25779,683172,655968,7220,568930,642770,303146,1036957,213079,233463,55212,725463,670365,61636,1041655,113349,273175,494054,53076,336125,1022766) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000961s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 904810 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000896s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 904810 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000765s ]