SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001151s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 539198 LIMIT 1 [ RunTime:0.000343s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 539198 [ RunTime:0.001813s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (388735,806781,644112,140992,334000,785079,929581,362373,42914,229720,634122,980762,317580,975385,422719,956082,71589,1030044,518171,22365,923011,201035,168716,793589,880125,569246,843667,575019,456659,681229,462520,568600,938040,971829,749265,518922,782869,1007258,361554,968505,6030,705066,626982,1015175,1033357,983867,318506,855281,315676,338236,521379,667280,281532,8588,1043305,740605,969151,832698,115010,275900) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001200s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 539198 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000618s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 539198 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000592s ]