SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001212s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 294102 LIMIT 1 [ RunTime:0.000610s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 294102 [ RunTime:0.001799s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (176401,636554,963038,646865,803523,304632,1040068,769918,653850,1013003,117268,756746,552669,863008,1039890,599897,5601,135185,377910,997460,934964,292402,501315,11735,578979,408429,832838,723753,55181,470291,684726,378096,108976,871774,265973,779275,824771,666571,631715,828570,854330,385109,67199,567545,382118,788551,382126,307629,440226,279298,846401,117960,808168,90386,1008192,30848,888830,837252,784416,1022228) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001106s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 294102 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000349s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 294102 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001039s ]