SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001117s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1025650 LIMIT 1 [ RunTime:0.000722s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1025650 [ RunTime:0.002164s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (262202,267711,757435,313246,228346,927415,784879,967784,779623,357941,457102,719264,34293,484922,685714,383475,83996,858445,837238,456328,537993,1030638,701638,728105,702498,182970,40123,531943,160818,473039,35983,541159,391450,925761,277150,250633,710165,387329,420032,828192,151865,316294,995547,901989,634114,937678,814077,380090,872316,908195,113824,455188,60477,916658,573233,485923,623938,951778,223835,307863) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001144s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1025650 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000499s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1025650 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001255s ]