SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001196s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 206760 LIMIT 1 [ RunTime:0.000350s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 206760 [ RunTime:0.001774s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (617069,864758,400991,26748,198531,445234,195136,50620,808757,784766,377865,536883,839036,20420,438764,182097,974960,439909,530356,420983,387206,361379,452632,148730,164455,154417,529535,36260,208556,581675,1031483,59353,402791,1015222,862069,636918,1128,541921,5494,883630,894475,1019971,817879,790439,306864,140141,227299,1044740,549924,905403,359107,418395,732335,690476,109445,870516,234735,357515,481325,619017) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001060s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 206760 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000376s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 206760 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000611s ]