SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001338s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 589283 LIMIT 1 [ RunTime:0.000410s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 589283 [ RunTime:0.003930s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (619188,460114,574131,739128,872043,887723,322163,234722,263819,15009,472994,332804,338682,63462,374865,282076,193457,134169,395454,332661,158778,907088,742545,51504,408470,792060,964380,788852,202325,809634,145425,674599,390623,556207,685685,549778,494308,890589,836912,41634,818196,952016,987250,49582,745553,489852,951435,1005589,271001,582735,338838,844705,731399,752697,999221,513648,40086,1041137,843142,905018) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001245s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 589283 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000545s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 589283 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000701s ]