SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001152s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 423228 LIMIT 1 [ RunTime:0.000324s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 423228 [ RunTime:0.002079s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (23749,524768,371897,265211,874601,303423,139780,52767,204904,183429,933196,545836,165668,1009892,1016872,105771,302752,592035,249517,21531,309719,918865,230744,854070,468491,868044,647111,840485,544059,725405,707652,429929,90529,20109,524893,111847,46925,644610,557841,576030,615462,980053,616884,826321,6074,89938,362987,709417,242162,648281,451418,175393,315324,69254,689714,218915,828462,402763,126786,365280) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001020s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 423228 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000331s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 423228 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000506s ]