SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001119s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 341090 LIMIT 1 [ RunTime:0.000359s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 341090 [ RunTime:0.002023s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (876402,736883,255518,848434,839952,123954,307426,375619,390754,311919,764310,47831,796475,726886,285730,171467,515251,211084,852568,389169,634263,475819,24901,453885,844267,468590,998982,29442,950039,187333,354924,272938,470696,553785,762439,665436,686591,619064,275564,347288,196805,1001715,529975,779137,616814,538890,333482,171724,390687,620608,433313,790326,70796,449098,313900,500353,367508,743813,609607,445467) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001111s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 341090 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000604s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 341090 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001193s ]