SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001169s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 394020 LIMIT 1 [ RunTime:0.000337s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 394020 [ RunTime:0.002001s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (53656,34766,939396,842159,216184,191225,1010151,402567,864419,663827,30706,542161,863536,667942,798667,262026,290838,31638,604272,484134,137170,502189,179241,627917,956503,733162,187109,834089,308501,939607,350704,496221,664921,7970,214174,974058,130228,709443,307832,722056,513422,198577,361657,105424,755664,739475,869314,437850,164638,209352,149918,809498,1046384,47678,511101,670240,957737,729884,503371,576099) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001038s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 394020 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000364s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 394020 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000580s ]