SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001095s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 861041 LIMIT 1 [ RunTime:0.000297s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 861041 [ RunTime:0.002210s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (565810,932627,108402,369810,608303,549837,610238,647096,812694,289951,668571,626861,357749,983933,319393,65490,565168,375390,457977,901303,83732,985420,13954,565651,542870,207281,393741,294421,648269,375519,388882,1023091,708457,954405,331583,603389,612158,920964,421893,905597,119716,30606,543209,30289,351660,722044,921149,735341,630800,928084,74737,587520,377494,807328,848117,396796,57597,1010143,208709,713379) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000999s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 861041 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000350s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 861041 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000445s ]