SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001231s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 303409 LIMIT 1 [ RunTime:0.000346s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 303409 [ RunTime:0.001844s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (34329,783902,215028,667981,109863,991580,844149,165456,917122,433982,380498,920201,12076,787456,482223,972278,34546,42083,475096,489222,1039818,954618,381660,106411,365584,271332,237767,726890,996861,968029,539665,840193,564420,913980,32347,947293,527207,812998,434354,27038,452063,19908,104081,768686,920153,488332,945946,414622,515765,201821,289170,75137,328453,299425,684271,540971,238323,801022,126033,382805) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001597s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 303409 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.003511s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 303409 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000640s ]