SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001264s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 304433 LIMIT 1 [ RunTime:0.000351s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 304433 [ RunTime:0.001591s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (104192,865545,150554,391963,31023,558656,986764,500051,1026837,710452,323335,281122,442717,241048,168798,810191,486655,182179,154683,996151,411412,861233,429763,647629,107546,532389,909064,432295,263189,378049,552553,374453,818923,819896,778441,919629,786153,337543,440062,347152,833236,293175,641189,134330,24726,553518,926010,1011827,53988,458462,76542,651253,929178,753856,346658,895532,541685,227704,299808,570382) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001087s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 304433 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000369s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 304433 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000581s ]