SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001128s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1020438 LIMIT 1 [ RunTime:0.000337s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1020438 [ RunTime:0.002696s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (130988,126683,334448,781061,111439,941992,886833,771538,683686,331003,32312,30777,367688,162274,514686,847837,913950,559257,890667,713681,495182,453995,812485,423878,885285,4372,759858,79971,257458,223618,281436,112911,499356,136004,409233,254841,236006,1105,837970,502538,547657,630700,701773,500117,604771,777803,740117,244407,933622,581819,526469,486218,818762,698615,517272,5933,821108,785503,592628,459996) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001329s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1020438 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001328s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1020438 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000577s ]