SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001148s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 516733 LIMIT 1 [ RunTime:0.000366s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 516733 [ RunTime:0.003233s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (478643,1003680,204842,589327,861759,414839,643090,2923,569418,529744,335694,173356,435108,557252,986829,9911,315080,253057,798265,885374,305515,121976,566035,927421,441660,678662,866429,473148,143509,653510,562969,505853,358444,200753,807378,473425,806638,253028,457383,866193,880280,762943,116124,461411,816942,975747,113318,115597,75128,596122,189491,67628,260804,706621,776486,128918,198163,458947,33237,731378) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001144s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 516733 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000898s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 516733 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000504s ]