SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001093s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 105991 LIMIT 1 [ RunTime:0.000337s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 105991 [ RunTime:0.001818s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (151660,787071,856760,486108,25959,867453,541799,1011098,54765,62970,906949,392678,109535,259725,895381,859749,71012,463359,1006012,75759,996301,996314,924929,730942,259858,375417,252622,485191,1017336,47935,403933,562553,89398,441447,132262,624978,820826,39350,456016,783619,1018773,304513,862550,393328,400940,775740,525536,210727,705318,58281,362989,100972,133792,946608,477853,569667,622614,652735,329155,471286) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001138s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 105991 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000464s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 105991 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.003385s ]