SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001280s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 898508 LIMIT 1 [ RunTime:0.000323s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 898508 [ RunTime:0.002225s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (458807,494244,410182,941329,415296,824632,841695,796916,668697,364744,197889,550697,1007534,73485,408208,6398,533183,807311,307796,219006,705913,410866,493330,528474,907943,857397,685651,759945,50475,437369,832989,456622,428759,175719,340173,920178,980230,968016,955406,573945,734022,440745,1045173,178139,252880,180579,730523,516991,1032259,1046577,120321,338190,1035418,192114,380320,767258,757648,481965,77266,156764) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000957s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 898508 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000398s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 898508 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000624s ]