SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002094s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 515368 LIMIT 1 [ RunTime:0.000330s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 515368 [ RunTime:0.001932s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (820394,975079,494502,83974,412133,544333,619640,2752,606547,231846,901224,732055,8434,504131,107743,626622,616238,896771,74556,338885,750751,189185,604110,526373,363529,292086,629834,781140,131959,890796,79333,444601,7847,799770,26550,407240,870365,542159,499698,352421,191252,184445,595147,287877,499014,1024979,74804,384937,239390,996826,155159,917781,26249,781455,531990,159518,704888,458338,273583,240912) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001267s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 515368 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000521s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 515368 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000548s ]