SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001147s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 495218 LIMIT 1 [ RunTime:0.000323s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 495218 [ RunTime:0.001656s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (953909,783345,115300,432538,278166,645271,166415,788722,802567,587684,880995,91430,4265,362961,821885,630608,870983,450703,523769,748889,103511,980525,363581,1042464,881654,89881,852764,205257,582094,379293,54221,1046050,127228,78678,190839,704690,460573,745930,1032671,167536,678785,658001,860718,976631,917126,606501,841121,753868,625632,451763,276787,318429,10761,771289,644940,114536,542781,377028,349827,1023003) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001412s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 495218 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000376s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 495218 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000619s ]