SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001556s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1014179 LIMIT 1 [ RunTime:0.000480s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1014179 [ RunTime:0.003965s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (549938,279878,259360,239611,144820,578170,664140,166597,1045955,751723,28299,693208,721247,752434,637500,723673,93727,838147,795277,500356,892680,283752,576573,673707,621546,691912,375701,455672,761669,351029,136617,851077,341897,5839,489483,237877,177141,388700,509320,641169,619811,694603,1008379,502674,620709,75863,844155,165609,365933,869039,119353,344564,829300,44751,595961,625587,635123,331961,240172,437774) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001046s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1014179 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000421s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1014179 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000612s ]