SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002205s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1040166 LIMIT 1 [ RunTime:0.000389s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1040166 [ RunTime:0.002564s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (141358,475253,366765,127631,863855,961570,676335,436850,1028643,726808,1022390,101404,637686,669611,146555,121810,670222,35582,1013402,604741,1044004,865135,520924,864661,418928,959488,68260,285827,56149,582135,135738,941928,202353,603029,343425,595392,851348,832977,326895,759036,294047,1048416,831270,463721,86139,989706,950347,955778,61608,216675,134026,517712,620069,555776,77636,871628,162744,349986,202860,773080) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001129s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1040166 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000532s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1040166 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000523s ]