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` = 502787 LIMIT 1 [ RunTime:0.000304s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 502787 [ RunTime:0.002159s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (551449,104503,1032856,84390,1001100,850590,420732,97764,41255,587626,942322,505448,222333,559856,935089,993489,442405,47751,323703,374762,951789,335948,319159,207116,959195,976231,94581,744957,881503,436748,484166,407320,12887,981957,711066,672578,544969,13716,365501,709068,586865,13551,395499,205238,434024,571635,600674,518646,445999,541255,860881,74916,677432,387785,471340,58278,280327,828522,1044484,68759) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001277s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 502787 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000345s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 502787 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000506s ]