SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001181s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 407140 LIMIT 1 [ RunTime:0.003108s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 407140 [ RunTime:0.005412s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (329112,21066,248755,406784,622443,445154,1017132,523218,871098,339246,650170,606216,441865,418129,889534,177317,690329,639506,135365,992386,58727,30204,960615,55331,206692,659526,113924,191561,722322,739077,897463,590970,617294,993494,1022669,605450,596404,81636,513988,978814,149042,560217,29231,748435,588330,44770,527851,607526,812455,980736,300856,620155,879028,158925,16930,135813,842579,669203,913843,350689) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003740s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 407140 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.002475s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 407140 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000556s ]