SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001376s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 987704 LIMIT 1 [ RunTime:0.000454s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 987704 [ RunTime:0.003577s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (529266,557250,363521,808547,451157,666825,31572,442353,944570,949818,361962,1031386,907922,973583,754860,794502,396321,1039931,294048,782492,1033717,199892,186635,789238,272032,359903,635688,537973,874070,297813,454393,283823,878228,347765,957239,577322,139227,301078,538179,786790,270954,163302,749681,455733,979321,337308,278935,597796,22174,268708,212634,1014638,35911,1017061,829776,402469,441675,33388,811294,178445) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001644s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 987704 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000394s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 987704 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000492s ]