SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001200s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 35427 LIMIT 1 [ RunTime:0.005461s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 35427 [ RunTime:0.004072s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (506733,582801,341191,354883,900364,712443,694017,458808,355487,431671,221800,312954,339618,508877,623096,929152,974936,813963,843655,113669,124826,241412,1035296,77356,1045413,102527,103421,391925,1016505,50545,736250,1014571,216413,851283,664678,811817,984617,118444,720793,995827,204107,593424,822019,891694,229307,209794,368395,797439,69069,449910,811929,223840,465726,523991,194073,423957,654204,997807,76822,941278) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.004357s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 35427 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001943s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 35427 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000639s ]