SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001242s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 34997 LIMIT 1 [ RunTime:0.000333s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 34997 [ RunTime:0.001615s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (110119,492385,427452,1018195,724651,596462,513212,276772,360207,92375,817411,778772,365832,187942,957628,489499,1020267,62248,741615,865860,901638,448861,66413,792387,824053,541626,912624,186030,59393,643930,954052,2299,321885,753518,620875,591336,152928,285998,33629,739321,651685,1036789,1039265,1012977,696543,175117,207614,236103,411989,539075,259716,727341,422570,773742,955169,312760,418535,325882,901251,567145) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001345s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 34997 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000662s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 34997 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000611s ]