SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001106s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 539328 LIMIT 1 [ RunTime:0.000364s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 539328 [ RunTime:0.001486s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (25291,734940,783923,164920,1029218,299949,1012117,665215,191572,152344,982863,635846,919394,669643,1015593,298563,16799,283796,742023,152436,253336,1004128,480347,888482,661418,591405,950827,13069,386510,570549,492714,834048,843523,587427,412917,58168,679992,143599,339203,237217,399351,877400,634825,604131,87698,215049,641712,681671,85023,1007937,979266,899595,1022028,961891,149197,568654,451200,222715,515699,525494) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001150s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 539328 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000360s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 539328 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000478s ]