SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003393s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 719760 LIMIT 1 [ RunTime:0.004813s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 719760 [ RunTime:0.008019s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (646940,353717,845478,367904,323469,940830,289535,546524,936302,227363,551940,41839,683087,216056,127048,605139,892543,337571,168909,1029914,517471,229184,851006,22616,430098,478885,1029244,512200,494348,62928,193858,130586,52210,655480,444833,866846,343624,389612,863927,721321,443048,193673,572295,186841,893900,873452,206997,598356,709648,121365,1024758,338276,736041,965056,975167,60612,998493,32840,191817,137943) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002452s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 719760 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000465s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 719760 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000603s ]