SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001182s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 391948 LIMIT 1 [ RunTime:0.000385s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 391948 [ RunTime:0.001951s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1047107,335747,231540,118767,1000565,748031,656119,889243,435767,329431,809752,804007,956758,572882,745677,695545,798940,632130,711067,203829,384160,375673,492355,842610,780920,689378,920788,336175,253575,901955,1041794,79982,87966,548235,122381,792695,114793,759647,362985,705077,1018812,766629,33684,893397,8474,68356,462360,512622,914436,316234,221910,118406,683863,1032899,481723,51055,735843,605941,879979,989814) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001032s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 391948 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000558s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 391948 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000500s ]