SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001418s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 406864 LIMIT 1 [ RunTime:0.000361s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 406864 [ RunTime:0.003074s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (963250,690109,310204,496884,706889,742164,496612,532020,1020812,3930,354421,925412,748223,484849,379060,597506,603573,821068,717365,573146,927877,732998,470101,117900,986767,181624,37888,662713,366395,669979,1014155,188404,198952,481285,550290,307542,977047,556590,874318,253901,619601,650910,65728,304049,212244,376617,496109,907365,830733,748545,566763,862273,147131,475686,950174,1036355,834335,394286,164028,1023290) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001261s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 406864 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000367s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 406864 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000456s ]