SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001210s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 503592 LIMIT 1 [ RunTime:0.001073s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 503592 [ RunTime:0.001587s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (792801,629156,251769,571595,753254,491500,711014,598909,34761,149423,141109,412968,19194,695272,88354,323151,259368,54225,510425,563219,300748,463655,723834,782368,812024,474118,198282,526448,928774,46079,708556,175400,661519,1009730,451134,5150,655118,911883,850028,308786,467035,246972,270678,606540,917547,81771,395559,332240,866024,515881,310627,1047101,105375,911807,933660,536040,608061,606368,410705,901147) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001000s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 503592 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000413s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 503592 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000811s ]