SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001189s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 496817 LIMIT 1 [ RunTime:0.000340s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 496817 [ RunTime:0.001798s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (498586,841739,887551,763142,219505,124246,149417,1039912,380567,232057,528353,718095,913296,587954,1040703,837059,220353,155904,834917,786008,614955,337065,471579,312522,882000,735017,791501,209661,195499,237306,390522,918999,199720,241183,444738,768650,113542,332910,995732,334149,345394,903981,29542,685250,441558,304746,434397,31501,405665,287598,836863,578513,758802,833594,136437,573294,50078,22392,26966,324422) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002057s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 496817 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000443s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 496817 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000598s ]