SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001267s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 403739 LIMIT 1 [ RunTime:0.000502s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 403739 [ RunTime:0.001537s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (276190,648751,279134,460119,375482,910392,111915,773507,327188,836395,58904,976722,2944,440413,1002438,492218,1001767,292270,633513,674982,1001039,9461,421288,883294,794692,183496,937499,620242,111193,20707,767259,1024170,195550,79736,13557,541255,487437,93519,683913,75818,985517,811060,834741,893735,30111,287161,267458,131773,929245,34004,188677,928842,152557,385262,354574,343447,479209,475211,619495,369267) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002368s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 403739 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000805s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 403739 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000522s ]