SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001174s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 266271 LIMIT 1 [ RunTime:0.000340s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 266271 [ RunTime:0.001588s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (969204,244283,65141,436383,561989,236344,174445,9799,797628,672288,49067,836388,399997,1025333,989297,529182,92577,792926,681696,1022093,936601,817194,458992,712096,327346,837759,740601,591082,589026,1005668,545894,119842,4939,176361,477355,867720,373619,720791,962838,604161,886774,811282,989496,747776,353604,201976,533615,545757,1040684,1042406,91141,513311,457033,113021,882003,787655,938011,6366,6116,489892) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001203s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 266271 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000468s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 266271 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000575s ]