SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001246s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 416075 LIMIT 1 [ RunTime:0.000393s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 416075 [ RunTime:0.001804s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (838839,90243,231453,180721,943433,916127,230675,181063,114845,251563,75748,10892,45884,825514,61551,703879,732712,326327,856293,493265,746305,951970,382013,892640,841669,825759,925167,1011511,651633,1037638,169729,63155,528682,48605,652163,530706,757890,202850,663447,181710,23794,381028,185332,798173,722178,417163,303398,695357,443070,728303,992732,257820,127954,138758,701367,653352,889190,513379,239712,318477) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001270s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 416075 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000376s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 416075 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000516s ]