SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003564s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 131712 LIMIT 1 [ RunTime:0.000322s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 131712 [ RunTime:0.001950s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (534015,860883,471336,985677,1027309,493449,825334,871321,660233,58560,777568,112950,47292,440164,230320,536488,979054,120240,694412,1009001,421640,239012,504980,910492,19020,983520,497106,886881,517315,92040,810988,235439,110869,569987,426533,423987,46271,580906,276620,422572,106733,193236,523751,533785,220456,894210,1034132,633543,248239,654737,18433,905935,512951,417551,948096,797339,766422,855930,942465,298365) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001039s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 131712 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000384s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 131712 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000620s ]