SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001173s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 539706 LIMIT 1 [ RunTime:0.000339s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 539706 [ RunTime:0.001874s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (15228,390059,698135,849570,529922,242484,543897,176779,53381,948050,950927,68414,731226,632081,509367,1036161,248809,818111,397781,357533,200056,835317,424793,450093,388046,563518,596952,469654,1029583,606362,567609,869809,864921,758575,901055,357399,820387,632443,393320,711083,1022594,674545,686250,10130,293040,471594,568684,829182,650978,31899,377574,861574,407910,916744,240121,802240,34268,269484,698854,324576) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000992s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 539706 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000382s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 539706 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000367s ]