SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001411s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 500358 LIMIT 1 [ RunTime:0.000398s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 500358 [ RunTime:0.002702s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (404408,145620,338205,351261,234306,57041,540771,310372,766607,548100,257320,393171,95921,770318,792565,410754,807120,96037,457758,665310,368648,337070,137315,542134,364458,537696,963984,23430,454803,985458,97733,504118,282373,209139,531051,700908,643558,848385,186466,188857,368057,67065,225409,1031989,976607,948227,327362,779962,392905,101458,899557,521575,572363,412260,967570,791146,807234,683124,394279,182031) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002689s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 500358 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.002854s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 500358 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000848s ]