SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001138s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1031807 LIMIT 1 [ RunTime:0.000349s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1031807 [ RunTime:0.001507s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1014815,148683,169188,1004193,482034,140755,320441,635009,92361,483360,594854,455113,702895,542920,278459,11014,992005,793347,316144,234911,297052,285308,234580,447855,588828,412647,262308,913654,238018,329299,107199,462276,445160,5437,180312,106419,568705,577852,823849,317250,352713,176864,73884,188015,738998,954769,516931,541521,16448,120923,342729,207872,98167,503060,1043858,81498,554928,725594,750729,205649) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001026s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1031807 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000375s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1031807 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000579s ]