SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001537s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 890613 LIMIT 1 [ RunTime:0.003084s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 890613 [ RunTime:0.001731s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (505301,736340,1018487,666288,403127,298886,49451,668021,715128,123200,887800,526208,784504,132111,710391,486961,676761,26632,248590,895450,335558,553744,639569,38788,507627,400882,843816,376824,359805,332218,977902,21794,935816,213393,247800,150707,606877,804237,902766,263310,67513,273356,132220,349038,59131,320047,71232,699543,17705,677046,1003910,515160,577493,1004541,143936,242098,983876,591393,837219,1007481) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001496s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 890613 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000600s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 890613 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000674s ]