SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001124s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1019041 LIMIT 1 [ RunTime:0.000319s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1019041 [ RunTime:0.001780s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (367610,549551,262547,260640,726911,632978,618974,441561,828301,331784,123477,173238,821911,214441,966225,165837,688588,805005,696070,366577,592925,3820,374114,991796,421566,796015,560400,886578,211134,201596,243155,955719,904878,352690,825109,877482,408479,190643,218183,701493,491371,346039,77913,964886,129141,33179,1030410,337005,294865,766243,691881,91123,813004,17946,630635,410438,940885,781228,229044,613851) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000984s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1019041 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000310s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1019041 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000499s ]