SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001162s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 573113 LIMIT 1 [ RunTime:0.000375s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 573113 [ RunTime:0.005361s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (509057,509059,345149,205272,96744,239415,951438,1012118,76786,737057,102024,596541,906552,444377,540035,790216,248537,579139,488216,1042294,363401,350641,1047462,991814,519125,84732,37836,429035,525428,379365,410877,991098,544534,157252,404371,252200,964444,530179,141724,251311,165960,244523,670180,1038134,559132,316744,919147,1021992,803289,886519,499167,32807,142829,460182,1020793,754767,1015706,947067,938025,416876) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002767s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 573113 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000409s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 573113 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000581s ]