SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003248s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 195429 LIMIT 1 [ RunTime:0.001900s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 195429 [ RunTime:0.002418s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (690143,95831,642343,207243,465623,214138,788468,142758,350182,406134,788870,164675,952396,821675,467939,256131,891614,209136,163012,687552,196785,837395,897354,432370,481185,638777,854206,664984,62392,587783,303210,875045,465025,53599,283072,492321,539320,789804,126332,62296,13274,269213,495804,114573,251792,197212,63926,726870,984814,838305,32209,802898,55511,154357,681694,984519,631992,806735,1044921,558836) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001128s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 195429 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000370s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 195429 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000401s ]