SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001150s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 543708 LIMIT 1 [ RunTime:0.000321s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 543708 [ RunTime:0.001766s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (424102,743596,513943,242616,894367,593117,437291,1048697,740972,977531,165443,260616,281568,419423,596767,981910,574007,1046711,620426,164811,824824,270108,422599,85675,526678,368165,957862,198336,718582,227995,657698,623048,783633,551049,149774,1038293,588363,287572,272070,329775,892377,243116,115734,219746,162099,1006819,106388,1023680,244224,786276,476935,434059,926553,957554,427472,1024380,280005,942810,24524,432517) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000960s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 543708 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000390s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 543708 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000588s ]