SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001165s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 531822 LIMIT 1 [ RunTime:0.000328s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 531822 [ RunTime:0.001609s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (569928,67407,925955,407583,1022838,845679,394975,59535,82744,614511,990783,20042,365838,808790,238398,721535,182130,649676,200163,690188,804138,641290,676116,978063,875232,197324,678087,633801,897139,436801,700704,111502,757885,715742,303608,928909,453244,417477,778706,617347,72976,39973,741264,296681,225912,417275,82031,531597,190046,359670,938201,960815,162403,907351,138786,815325,245004,130466,997800,111202) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001043s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 531822 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000372s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 531822 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000568s ]