SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001576s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 265319 LIMIT 1 [ RunTime:0.000324s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 265319 [ RunTime:0.001490s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1036544,111153,11731,790440,558842,790222,279251,112801,164627,257443,1044329,821574,897017,276272,89424,668528,930495,171237,385387,72109,311909,700890,912246,283167,439257,377075,320509,988750,665471,512360,995571,338419,814350,585071,407916,169146,572511,739842,231505,1007239,867158,852698,92151,579104,376779,296734,538932,654084,589720,33831,282352,727215,458425,642837,44024,296012,1018737,875394,793891,794023) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001407s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 265319 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000363s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 265319 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000629s ]