SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.000951s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 267501 LIMIT 1 [ RunTime:0.000322s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 267501 [ RunTime:0.005065s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (768418,912081,896238,798195,515013,789768,442383,929022,664547,309574,315530,804692,942688,153548,549911,225844,875430,144199,839797,841419,957518,558856,547348,110913,42505,812513,751608,1045037,25308,809591,305384,917706,814593,1002087,405422,484586,645818,163149,28547,785663,876905,239111,71305,717246,64293,596550,258588,58391,410935,563848,339915,364491,862331,173785,620608,250114,411710,134108,682980,71197) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001019s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 267501 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000421s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 267501 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000441s ]