SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001315s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1017091 LIMIT 1 [ RunTime:0.000652s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1017091 [ RunTime:0.004052s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (619821,883677,680448,844140,10916,707952,900207,951159,707901,527749,311147,281760,971116,402000,277639,995744,894931,905377,441830,989944,321044,682050,1023879,890127,271437,768485,72254,975837,33965,33370,770439,560164,494090,635552,753730,310969,642861,215472,163201,204810,1025750,1026321,835337,976395,748603,823569,985545,39056,762786,133313,681216,233783,821120,417152,640296,78230,371668,1001140,404660,29698) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001186s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1017091 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000436s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1017091 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000624s ]