SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001327s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 405567 LIMIT 1 [ RunTime:0.000405s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 405567 [ RunTime:0.001850s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (308180,1038034,928484,854284,304898,421095,754928,771744,222661,621805,556555,173244,10253,408835,177523,599049,317805,602648,498321,180984,425727,483526,825778,66091,604890,660496,592118,917375,567417,741404,71857,418044,365356,505763,671377,759005,402761,593938,853697,138466,731175,315764,1021884,354327,532701,114851,958837,13139,838511,146130,224356,805262,203707,396420,815819,281115,992774,869693,907606,86558) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.007179s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 405567 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000473s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 405567 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000600s ]