SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001266s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 681453 LIMIT 1 [ RunTime:0.000360s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 681453 [ RunTime:0.001429s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (258912,954220,502783,434213,173983,1025316,24571,576874,968244,565286,717403,817583,960613,782572,832046,76680,984727,631000,212415,716984,437485,1007152,64590,351605,1026544,485132,609156,53349,226436,165427,58848,476118,324690,479345,863181,944078,911716,1035540,430497,565661,836144,53529,81486,302770,738519,258803,731227,672652,413817,475160,89323,670173,575067,626896,987195,521102,247344,22760,801644,694549) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001296s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 681453 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000641s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 681453 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000615s ]