SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001527s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 252913 LIMIT 1 [ RunTime:0.000316s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 252913 [ RunTime:0.001564s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (895072,25835,1030246,502581,82606,362951,919711,370613,419139,712078,837904,687664,663628,76044,372730,503511,738703,651753,946890,940058,949491,194898,43059,993101,697719,653258,884643,625593,525375,329528,342936,300828,393683,551954,712135,724844,65205,700043,412343,615747,48294,415641,570272,539229,604215,1020608,127142,495340,258179,428642,417182,413990,100263,1016477,676495,458239,232041,801260,839409,542196) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001090s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 252913 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000367s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 252913 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000404s ]