SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001170s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 506017 LIMIT 1 [ RunTime:0.000335s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 506017 [ RunTime:0.001796s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (736445,871023,508014,479843,630529,864094,169014,759705,180480,760180,6908,353694,8929,1009031,818195,687838,758033,182510,435543,21687,346737,334864,317715,14099,75431,657878,504045,426612,79790,142017,498035,521668,624770,221125,610149,763643,151639,629001,729638,722428,43762,64592,342766,623090,625545,307905,540960,355809,739399,289826,173799,59826,735382,929995,353141,104879,640582,322058,638385,292426) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001786s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 506017 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000731s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 506017 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000611s ]