SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001148s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 195581 LIMIT 1 [ RunTime:0.000318s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 195581 [ RunTime:0.001957s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (86230,707410,85763,549978,261518,484968,464128,954514,7354,561650,235340,403120,248348,300153,455568,942697,628166,134879,880405,481223,361108,827162,585349,55906,769661,391903,132843,593215,9968,374374,271383,29230,234673,773259,953498,832062,788689,159424,893097,735891,399118,526157,223950,860684,652929,330070,1011891,614945,544955,490023,323563,698129,649537,607587,167380,227560,614034,422501,258523,825708) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001013s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 195581 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000358s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 195581 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000484s ]