SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001165s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 140814 LIMIT 1 [ RunTime:0.000324s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 140814 [ RunTime:0.001422s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (540220,975951,852227,998298,110914,93903,124967,694058,134449,52460,944485,140031,684837,128933,489194,606471,169677,671830,657592,531378,307585,983165,517646,121487,438523,207757,191420,330472,259608,584887,958465,483042,201934,171151,354588,578083,12703,281215,807472,571228,106976,699942,689130,820157,222266,1030426,784826,990638,463379,668327,132534,398525,618603,1011532,846421,824804,178934,472799,644188,457317) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001051s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 140814 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000377s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 140814 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000513s ]