SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001326s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 572320 LIMIT 1 [ RunTime:0.000335s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 572320 [ RunTime:0.004640s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (227945,430958,269980,811787,213066,187779,216468,1045154,522277,841579,372188,691779,226698,717199,247028,169152,478059,1046885,891417,52622,22532,839809,783483,550305,698660,944284,605956,1033345,507875,418762,405790,1011968,510154,560486,158563,575167,223711,780991,395248,236443,432681,448788,625088,183373,1042411,89717,240344,365015,363519,541752,923472,366823,577310,221869,1011480,892491,71786,168693,293597,941012) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002440s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 572320 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.003411s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 572320 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000647s ]