SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001137s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 577078 LIMIT 1 [ RunTime:0.000905s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 577078 [ RunTime:0.003029s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (333889,1029330,758393,190381,513837,1026545,481357,557663,783271,469848,517464,197050,151765,393784,290787,37345,351681,1011388,282674,714514,845944,880069,246107,796745,186301,114715,126617,366541,488894,773082,150073,1030375,571557,4150,917376,936638,59552,711134,683165,536987,1010525,921522,152091,929678,487554,983191,184146,848997,437446,126583,922685,653294,878088,363149,877232,493494,591158,341402,423803,295766) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003801s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 577078 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.005093s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 577078 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.004388s ]