SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001133s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 427845 LIMIT 1 [ RunTime:0.000421s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 427845 [ RunTime:0.001973s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (131782,755474,853140,417607,278582,172602,400806,841851,755201,501291,369362,279219,912234,759950,511809,274326,858846,450883,698639,1022068,595865,567619,836362,111254,313320,504721,667542,223286,697853,395558,1032447,544116,427283,105250,349277,822247,92358,235483,238493,602853,932711,622526,453508,1009417,3602,296541,160940,558625,870294,893975,755481,751649,1018573,417735,844985,835147,669509,916557,694502,64039) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001457s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 427845 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000488s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 427845 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000598s ]