SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001163s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 205689 LIMIT 1 [ RunTime:0.000380s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 205689 [ RunTime:0.001656s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (486807,435048,955715,485108,732395,354278,950564,274457,428761,380665,798083,839751,979795,647155,576672,217278,295386,370737,515860,1043884,24240,793374,949170,743647,292108,901535,211776,860574,105849,555432,514232,241748,586123,276523,677518,735221,84103,842417,111440,229427,851461,836315,779937,1037080,468903,291030,296102,496320,450713,866619,550266,510488,538783,790003,422286,967077,310000,199702,1024817,254909) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001033s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 205689 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000367s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 205689 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000578s ]