SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001521s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 301354 LIMIT 1 [ RunTime:0.002196s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 301354 [ RunTime:0.001723s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (287817,115321,675552,539663,776421,1001226,950575,525758,591680,853607,428244,602539,122220,615130,746903,398857,582275,197013,215630,1028204,308061,919042,109427,404967,713444,251052,866472,320312,297408,369618,637538,582475,559116,281228,1043826,610309,33278,975951,243722,117514,636614,790135,23044,243436,762565,336322,897808,926600,709121,408012,721159,30761,292543,785213,589397,449668,176831,180981,443210,270997) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003562s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 301354 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000431s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 301354 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000640s ]