SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001212s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 477213 LIMIT 1 [ RunTime:0.000369s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 477213 [ RunTime:0.003076s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (402162,607358,770609,735079,648941,814442,293829,425884,483880,810824,920934,141009,671257,245609,1020506,1032320,338888,127418,1029028,351088,212608,982908,178017,122092,898671,881514,440711,276651,544387,1009253,826497,665048,306960,322239,161257,335310,51498,477483,391654,189428,223833,15223,288454,55774,33934,48689,945850,157837,218410,442322,938809,778407,164205,23533,495089,854790,56451,981007,898371,270060) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001583s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 477213 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000797s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 477213 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.003427s ]