SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001302s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 596998 LIMIT 1 [ RunTime:0.000428s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 596998 [ RunTime:0.001964s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (316717,848911,182899,769202,962827,593655,787010,743083,894804,480472,748817,344679,59098,520816,428357,531807,844808,14993,583362,328996,387003,862544,500890,1013648,498775,619918,298254,922705,299684,165796,448174,1011648,279378,138657,343377,160809,87127,120530,723240,670296,147674,552735,823559,555230,374569,459210,451698,596279,405149,251952,601523,438640,577248,954748,656390,749735,941097,1027050,590017,1026803) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001295s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 596998 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000447s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 596998 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000572s ]