SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001149s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 570815 LIMIT 1 [ RunTime:0.000380s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 570815 [ RunTime:0.001803s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (240382,146770,788707,358203,914050,827075,638333,253627,435681,694570,892817,1042455,501248,743678,232748,132851,476507,415771,345600,444247,650551,648128,843039,256258,627793,948768,591776,149896,245279,440199,284286,750070,69333,203603,392133,105596,859373,530660,636937,735826,263595,816442,947613,923258,524916,408016,551592,681758,88724,535281,600416,16873,193247,457321,164240,193439,880279,736927,336306,28524) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001009s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 570815 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000338s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 570815 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000518s ]