SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001534s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 146110 LIMIT 1 [ RunTime:0.000449s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 146110 [ RunTime:0.001943s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (567267,246836,666369,679914,147014,126446,101942,890257,1008009,596746,509189,352968,617090,901354,992841,691860,804207,520555,217097,837294,981060,18294,845701,343934,201005,150479,965335,754384,493733,652639,88719,360275,918321,305598,828480,291385,398312,314803,43937,947891,173931,656205,128537,116575,900160,587781,85892,741323,969389,396417,898578,705291,9140,461010,253608,566455,53517,789036,336237,103560) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001558s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 146110 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000676s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 146110 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000536s ]