SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002283s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 38547 LIMIT 1 [ RunTime:0.000381s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 38547 [ RunTime:0.001924s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (99752,100279,360398,408357,895110,172012,1022978,888159,38202,1013552,13354,642682,724617,575450,629931,1042225,508270,449248,504566,310462,551245,737942,200315,1007470,142170,162794,611400,811695,599622,754229,832411,644891,1017237,325412,249153,983880,1009003,23091,52041,617024,970446,907509,121531,816992,968655,73209,461619,355063,412179,755004,384471,48575,159529,494025,1038161,842714,118341,398971,154611,254648) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001185s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 38547 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000387s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 38547 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000883s ]