SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001401s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 171227 LIMIT 1 [ RunTime:0.000693s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 171227 [ RunTime:0.003751s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (578059,944443,472456,213593,145310,155737,622253,751127,228984,429766,551403,127674,865131,465581,215771,207261,137819,960797,401222,256548,281120,333491,285482,701468,851661,608725,310971,887915,901972,476044,435424,523865,813639,452283,577256,722732,33661,96183,709729,444548,589745,812134,993836,70667,836275,766375,644081,750250,509574,996143,23461,230477,770066,718827,578952,126855,888494,725618,783716,234558) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001311s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 171227 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000568s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 171227 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000607s ]