SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001277s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 537703 LIMIT 1 [ RunTime:0.000400s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 537703 [ RunTime:0.001516s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (495115,912121,164688,99311,311293,152992,343319,130028,951054,324345,884992,895830,74439,217107,281549,480813,208830,177655,8942,477717,630119,568696,374529,562665,847144,726137,66596,273124,66982,956379,354475,281148,567592,969886,763546,81927,450260,396201,642321,159475,715675,995508,770029,857765,422981,468907,774390,968551,548351,985269,405315,709029,249061,577706,214921,693534,530318,801802,493974,300973) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001069s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 537703 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000482s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 537703 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000479s ]