SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001216s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 503133 LIMIT 1 [ RunTime:0.000386s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 503133 [ RunTime:0.002845s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (331711,501079,261519,591280,746848,313593,563084,678799,171365,976158,362828,508662,604636,422060,609027,96856,679199,356463,720237,927974,348734,17065,236655,575457,747347,439691,18179,867184,202319,281389,870332,935041,744416,996622,618887,784253,227525,350442,956115,755816,991078,910483,212520,1026101,148955,553830,1026054,787101,233132,484825,484699,244703,474837,861046,41159,38351,338195,895481,887039,189888) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001197s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 503133 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000398s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 503133 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000512s ]