SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001220s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1005315 LIMIT 1 [ RunTime:0.001905s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1005315 [ RunTime:0.003393s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (825884,919226,523778,399289,590908,852559,350183,1023872,639710,1011698,1013468,883393,880872,1046064,718750,702872,51798,1041825,1029461,621115,962898,738916,368721,574373,640496,491936,432290,667836,440120,544074,733378,643120,475999,356775,657320,136287,926841,409566,164062,910474,733761,869803,576315,499668,107872,409413,555997,240712,242119,730429,891420,876456,592586,746064,52557,874152,851476,735043,383654,125411) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.036181s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1005315 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000524s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1005315 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.005823s ]