SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001176s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 264528 LIMIT 1 [ RunTime:0.000313s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 264528 [ RunTime:0.001777s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1013263,109166,719662,817639,963385,979501,704822,842558,482248,484481,567997,467848,79275,614090,775043,64454,978793,907958,413884,903262,143268,1005937,386892,208651,774853,959455,113720,30729,971417,342739,336628,68475,235193,613004,839036,711403,165962,433005,744253,708196,840122,20895,904023,362038,869469,14803,914534,463672,1007054,1036965,677957,33516,337659,552449,728434,489065,560752,183456,663799,774626) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001414s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 264528 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000401s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 264528 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000546s ]