SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001257s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1005354 LIMIT 1 [ RunTime:0.000400s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1005354 [ RunTime:0.002510s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (801657,444767,276439,687352,207196,389844,320419,993253,60706,201550,247162,904039,48080,788826,639754,336080,596462,985073,774798,529358,533500,1033294,13356,667502,1018365,1010601,811396,873541,939219,600174,604281,278709,453078,232988,340997,951570,26087,635902,40410,360104,676377,190024,980434,899962,193547,670506,892638,167126,413932,106817,698966,874585,110596,425983,52354,847088,947127,944735,480152,968293) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001536s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1005354 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001165s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1005354 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000524s ]